<?php
    $db_host="localhost";
    $db_user="root";
    $db_psw="root";
    $db_name="csvimport";
    $conn = mysqli_connect($db_host,$db_user,$db_psw) or die("Connection occur error");
    mysqli_select_db($conn,$db_name,$conn) or die("Connection occur error");
    mysqli_query($conn,"set names utf-8"); 
    mysqli_query($conn,"LOAD DATA INFILE 'D:\csv\yiqing.csv' INTO TABLE `billdata` FIELDS TERMINATED BY ',' ENCLOSED BY '\"' ESCAPED BY '\"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;") or die ('Error: '.mysqli_error ()); 
?>